<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.util.List" %><%--
  Created by IntelliJ IDEA.
  User: zzy
  Date: 2018/3/22
  Time: 16:25
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
  <head>
    <title>$Title$</title>
  </head>
  <body>
  <style type="text/css">

    table {

      border-collapse: collapse;
    }

    td {

      border: 1px solid #000;
      padding: 10px;
    }
  </style>

  <table>
    <tr>
      <td>编号</td>
      <td>姓名</td>
      <td>密码</td>
      <td>操作1</td>
      <td>操作2</td>
    </tr>


      <%




  // 3+1
  Connection connection = null;
  Statement statement = null;
  ResultSet resultSet = null;

  // t_users
  String sql = "select * from t_user";

  Class.forName("com.mysql.jdbc.Driver");

  connection = DriverManager.getConnection(
          "jdbc:mysql://localhost:3306/sctu_javaweb_2018?serverTimezone=UTC",
          "root",
          "123456"
  );
  statement = connection.createStatement();

  resultSet = statement.executeQuery(sql);
  class User{
      int id;
      String username;
      String password;
  }
  List <User> userList =  new ArrayList<>();
   while(resultSet.next()){


            int id = resultSet.getInt(1);
            String username = resultSet.getString(2);
            String password = resultSet.getString(3);

            // 封装
            User user = new User();
            user.id = id;
            user.username = username;
            user.password = password;

            userList.add(user);
        }


        resultSet.close();
        statement.close();
        connection.close();


        for (User user :userList){
             out.write("<tr><td>" + user.id +
                    "</td><td>" + user.username +
                    "</td><td>" + user.password +
                    "</td><td>" +
                    "<a href='delete.jsp?id="
                    +user.id+"'>删除</a></td>" +
                    "<td><a href='update.jsp?id="+user.id+"&username="+user.username+"&password="+user.password+"'>更新</a></td></tr>");
        }
%>
  </body>
</html>
